Formatting And Editting in MS Excel
Formatting Toolbar in MS Excel
The formatting toolbar found in most applications with text editing features is used to change the format of selected text. It contains a series of icons that act as shortcuts to frequently used formatting commands. The series are as follows:-| Font - Provides a list of all the available fonts (based on your current printer selection). |
| Font Size - Lets you adjust the character size (based on your current font selection). |
| Bold - Toggles bold on the current selection. |
| Italic - Toggles italics on the current selection. |
| Underline - Toggles underline on the current selection. |
| Align Left - Aligns data to the left edge of the cell. |
| Center - Aligns data in the middle of the cell. |
| Align Right - Aligns data to the right edge of the cell. |
| Wrap Text - Text inside the cell wraps to fit the column width. Text wrapping adjusts automatically when you change the column width. |
| Merge and Center - Combines 2 or more adjacent cells to create a single cell. |
| Currency Style - Applies the currency format "£##". |
| Percent Style - Displays the number as a percentage by applying the format "0%". |
| Comma Style - Adds a comma and two decimal places to the number by applying the format "#,##0.00". |
| Increase Decimal - Adds one decimal place from the number. |
| Decrease Decimal - Removes one decimal place from the number. |
| Decrease Indent - Decreases the indent by 1 or removes the indent completely. |
| Increase Indent - Increases the indent by 1. |
| Borders - Applies a border to the current selection. |
| Fill Color - Applies a color to the background of the current selection. This is actually a tear off toolbar. |
| Font Color - Changes the color of the font of the current selection. This is actually a tear off toolbar. |
___________________ function displays row data in a column or column data in a row . | |||
| Right Option : C | |||
| View Explanation | |||
In an Excel sheet, a cell with a text overflow problem can be dealt with using which of the following? | |||
| Right Option : D | |||
| View Explanation | |||
You can create hyperlinks from the Excel workbook to __________ . | |||
| Right Option : D | |||
| View Explanation | |||
Students / Parents Reviews [10]
Being a parent, I saw my daughter improvement in her studies by seeing a good result in all day to day compititive exam TMO, NSO, IEO etc and as well as studies. I have got a fruitful result from my daughter.
Prisha Gupta
8thAbout Abhyas metholodology the teachers are very nice and hardworking toward students.The Centre Head Mrs Anu Sethi is also a brilliant teacher.Abhyas has taught me how to overcome problems and has always taken my doubts and suppoeted me.
Shreya Shrivastava
8thIt was good as the experience because as we had come here we had been improved in a such envirnment created here.Extra is taught which is beneficial for future.
Eshan Arora
8thMy experience with Abhyas academy is very good. I did not think that my every subject coming here will be so strong. The main thing is that the online tests had made me learn here more things.
Hiya Gupta
8thI have spent a wonderful time in Abhyas academy. It has made my reasoning more apt, English more stronger and Maths an interesting subject for me. It has given me a habbit of self studying
Yatharthi Sharma
10thIt was a good experience with Abhyas Academy. I even faced problems in starting but slowly and steadily overcomed. Especially reasoning classes helped me a lot.
Cheshta
10thOne of the best institutes to develope a child interest in studies.Provides SST and English knowledge also unlike other institutes. Teachers are co operative and friendly online tests andPPT develope practical knowledge also.
Aman Kumar Shrivastava
10thMy experience was very good with Abhyas academy. I am studying here from 6th class and I am satisfied by its results in my life. I improved a lot here ahead of school syllabus.
Ayan Ghosh
8thMy experience with Abhyas is very good. I have learnt many things here like vedic maths and reasoning also. Teachers here first take our doubts and then there are assignments to verify our weak points.
Shivam Rana
7thAbhyas is a complete education Institute. Here extreme care is taken by teacher with the help of regular exam. Extra classes also conducted by the institute, if the student is weak.
